TG: sql_for_qa/94

SQL для тестировщика

Дана таблица "orders" c колонками "order_id", "customer_id", "order_date" и "total_amount". Какой из следующих SQL запросов выведет общую сумму заказов в разрезе покупателей?

Anonymous Quiz

SELECT customer_id, COUNT(order_id) FROM orders GROUP BY customer_id;

SELECT customer_id, AVG(total_amount) FROM orders GROUP BY customer_id;

SELECT customer_id, MAX(total_amount) FROM orders GROUP BY customer_id;

SELECT customer_id, SUM(total_amount) FROM orders GROUP BY customer_id;

542 answered

www.tg-me.com/jp/SQL для тестировщика/com.sql_for_qa/94

2.5K viewsMay 19, 2023 at 11:12

tg-me.com/sql_for_qa/94

Create: 2023-05-19
Last Update: 2025-07-02 05:07:29

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/94

SQL для тестировщика Telegram | DID YOU KNOW?

Pinterest (PINS) Stock Sinks As Market Gains

Pinterest (PINS) closed at $71.75 in the latest trading session, marking a -0.18% move from the prior day. This change lagged the S&P 500's daily gain of 0.1%. Meanwhile, the Dow gained 0.9%, and the Nasdaq, a tech-heavy index, lost 0.59%. Heading into today, shares of the digital pinboard and shopping tool company had lost 17.41% over the past month, lagging the Computer and Technology sector's loss of 5.38% and the S&P 500's gain of 0.71% in that time. Investors will be hoping for strength from PINS as it approaches its next earnings release. The company is expected to report EPS of $0.07, up 170% from the prior-year quarter. Our most recent consensus estimate is calling for quarterly revenue of $467.87 million, up 72.05% from the year-ago period.

Mr. Durov launched Telegram in late 2013 with his brother, Nikolai, just months before he was pushed out of VK, the Russian social-media platform he founded. Mr. Durov pitched his new app—funded with the proceeds from the VK sale—less as a business than as a way for people to send messages while avoiding government surveillance and censorship.